INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1106, '流程管理', 0, 50, 'flow', NULL, NULL, 1, 0, 'M', '0', '0', '', 'cascader', 'admin', '2023-04-11 11:02:28', 'admin', '2023-10-26 17:21:32', '');

INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1107, '流程定义', 1106, 1, 'definition', 'flow/definition/index', NULL, 1, 0, 'C', '0', '0', 'flow:definition:list', 'online', 'admin', '2023-04-11 13:06:38', 'admin', '2023-04-13 13:00:05', '流程定义菜单');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1109, '流程定义新增', 1107, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'flow:definition:add', '#', 'admin', '2023-04-11 13:06:38', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1111, '流程定义修改', 1107, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'flow:definition:edit', '#', 'admin', '2023-04-11 13:06:38', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1112, '流程定义删除', 1107, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'flow:definition:remove', '#', 'admin', '2023-04-11 13:06:38', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1124, '导入流程定义', 1107, 11, '', NULL, NULL, 1, 0, 'F', '0', '0', 'flow:definition:importDefinition', '#', 'admin', '2023-06-04 23:52:33', '', NULL, '');

INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1118, '待办任务', 1106, 2, 'todo', 'flow/task/todo/index', NULL, 1, 0, 'C', '0', '0', 'flow:execute:toDoPage', 'guide', 'admin', '2023-04-17 17:21:21', 'admin', '2023-06-11 00:33:39', '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1122, '已办任务', 1106, 3, '1', 'flow/task/done/index', NULL, 1, 0, 'C', '0', '0', 'flow:execute:donePage', 'druid', 'admin', '2023-05-06 13:01:37', 'admin', '2023-06-02 08:59:50', '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1123, '已办任务历史记录', 1122, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'flow:execute:doneList', '#', 'admin', '2023-06-02 13:12:11', '', NULL, '');

INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1061, '测试菜单', 0, 60, 'test', NULL, NULL, 1, 0, 'M', '0', '0', '', 'example', 'admin', '2023-03-17 18:15:12', 'admin', '2023-10-26 17:21:45', '');

INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1092, 'OA 请假申请', 1061, 1, 'leave', 'test/leave/index', NULL, 1, 0, 'C', '0', '0', 'test:leave:list', '#', 'admin', '2023-04-02 18:14:21', '', NULL, 'OA 请假申请菜单');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1094, 'OA 请假申请新增', 1092, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'test:leave:add', '#', 'admin', '2023-04-02 18:14:21', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1095, 'OA 请假申请详情', 1092, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'test:leave:detail', '#', 'admin', '2023-04-02 18:14:21', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1096, 'OA 请假申请修改', 1092, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'test:leave:edit', '#', 'admin', '2023-04-02 18:14:21', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1097, 'OA 请假申请删除', 1092, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'test:leave:remove', '#', 'admin', '2023-04-02 18:14:21', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1098, 'OA 请假申请导出', 1092, 6, '#', '', NULL, 1, 0, 'F', '0', '0', 'test:leave:export', '#', 'admin', '2023-04-02 18:14:21', '', NULL, '');


DROP TABLE IF EXISTS `flow_definition`;
CREATE TABLE `flow_definition` (
                                   `id` bigint unsigned NOT NULL COMMENT '主键id',
                                   `flow_code` varchar(40) NOT NULL COMMENT '流程编码',
                                   `flow_name` varchar(100) NOT NULL COMMENT '流程名称',
                                   `version` varchar(20) NOT NULL COMMENT '流程版本',
                                   `is_publish` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否发布（0未发布 1已发布 9失效）',
                                   `from_custom` char(1) DEFAULT 'N' COMMENT '审批表单是否自定义（Y是 N否）',
                                   `from_path` varchar(100) DEFAULT NULL COMMENT '审批表单路径',
                                   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                                   PRIMARY KEY (`id`) USING BTREE,
                                   UNIQUE KEY `flow_code_version` (`flow_code`,`version`) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC COMMENT='流程定义表';

-- ----------------------------
-- Records of flow_definition
-- ----------------------------
BEGIN;
INSERT INTO `flow_definition` (`id`, `flow_code`, `flow_name`, `version`, `is_publish`, `from_custom`, `from_path`, `create_time`, `update_time`) VALUES (1164575944237780992, 'leaveFlow-serial1', '串行-简单', '1.0', 1, 'N', 'test/leave/approve', '2023-10-19 14:49:02', '2023-12-27 02:19:09');
INSERT INTO `flow_definition` (`id`, `flow_code`, `flow_name`, `version`, `is_publish`, `from_custom`, `from_path`, `create_time`, `update_time`) VALUES (1164575944237780993, 'leaveFlow-serial2', '串行-通过互斥', '1.0', 1, 'N', 'test/leave/approve', '2023-10-19 14:49:02', '2023-12-27 11:23:27');
INSERT INTO `flow_definition` (`id`, `flow_code`, `flow_name`, `version`, `is_publish`, `from_custom`, `from_path`, `create_time`, `update_time`) VALUES (1164575944237780994, 'leaveFlow-parallel1', '并行-汇聚', '1.0', 1, 'N', 'test/leave/approve', '2023-10-19 14:49:02', '2023-12-27 02:19:17');
INSERT INTO `flow_definition` (`id`, `flow_code`, `flow_name`, `version`, `is_publish`, `from_custom`, `from_path`, `create_time`, `update_time`) VALUES (1164575944237780995, 'leaveFlow-parallel2', '并行-分开', '1.0', 1, 'N', 'test/leave/approve', '2023-10-19 14:49:02', '2023-12-27 02:19:21');
INSERT INTO `flow_definition` (`id`, `flow_code`, `flow_name`, `version`, `is_publish`, `from_custom`, `from_path`, `create_time`, `update_time`) VALUES (1164867267142488064, 'leaveFlow-serial3', '串行-驳回互斥', '1.0', 1, 'N', 'test/leave/approve', '2023-10-20 10:06:39', '2023-12-27 11:23:26');
COMMIT;

-- ----------------------------
-- Table structure for flow_his_task
-- ----------------------------
DROP TABLE IF EXISTS `flow_his_task`;
CREATE TABLE `flow_his_task` (
                                 `id` bigint unsigned NOT NULL COMMENT '主键id',
                                 `definition_id` bigint NOT NULL COMMENT '对应flow_definition表的id',
                                 `instance_id` bigint NOT NULL COMMENT '对应flow_instance表的id',
                                 `tenant_id` varchar(40) DEFAULT NULL COMMENT '租户id',
                                 `node_code` varchar(100) DEFAULT NULL COMMENT '开始节点编码',
                                 `node_name` varchar(100) DEFAULT NULL COMMENT '开始节点名称',
                                 `node_type` tinyint(1) NOT NULL COMMENT '开始节点类型（0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关）',
                                 `target_node_code` varchar(100) DEFAULT NULL COMMENT '目标节点编码',
                                 `target_node_name` varchar(100) DEFAULT NULL COMMENT '结束节点名称',
                                 `approver` varchar(40) DEFAULT NULL COMMENT '审批者',
                                 `permission_flag` varchar(200) DEFAULT NULL COMMENT '权限标识（权限类型:权限标识，可以多个，如role:1,role:2)',
                                 `flow_status` tinyint(1) NOT NULL COMMENT '流程状态（0待提交 1审批中 2 审批通过 8已完成 9已驳回 10失效）',
                                 `gateway_node` varchar(40) DEFAULT NULL COMMENT '所属并行网关节点编码',
                                 `message` varchar(500) DEFAULT NULL COMMENT '审批意见',
                                 `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                 `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                                 PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC COMMENT='历史任务记录表';

-- ----------------------------
-- Records of flow_his_task
-- ----------------------------
BEGIN;
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189227307726934017, 1164575944237780992, 1189227307726934016, '000000', '2', '待提交', 1, '3', '组长审批', '1', 'role:1,role:2', 2, NULL, NULL, '2023-12-26 15:24:50', '2023-12-26 15:24:50');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189227327272390656, 1164575944237780992, 1189227307726934016, '000000', '3', '组长审批', 1, '4', '部门经理审批', '1', 'role:1,role:3', 2, NULL, '1', '2023-12-26 15:34:28', '2023-12-26 15:34:28');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189227403407396865, 1164867267142488064, 1189227403407396864, '000000', '2', '中间节点1', 1, '0fbb9fbe-e4bd-4280-94f4-a8f939b760e2', '中间节点2', '1', NULL, 2, NULL, NULL, '2023-12-26 15:25:13', '2023-12-26 15:25:13');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189227425637208064, 1164867267142488064, 1189227403407396864, '000000', '0fbb9fbe-e4bd-4280-94f4-a8f939b760e2', '中间节点2', 1, '80e10f4c-452c-4a79-b608-84e75831a437', '中间节点3', '1', NULL, 2, NULL, 'undefined', '2023-12-26 15:34:49', '2023-12-26 15:34:49');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189227464279330816, 1164575944237780993, 1189227464275136512, '000000', '2', '待提交', 1, '3', '组长审批', '1', 'role:1,role:3', 2, NULL, NULL, '2023-12-26 15:25:25', '2023-12-26 15:25:25');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189227474274357248, 1164575944237780993, 1189227464275136512, '000000', '3', '组长审批', 1, '4', '大组长审批', '1', 'role:1,role:3', 2, NULL, 'undefined', '2023-12-26 15:34:00', '2023-12-26 15:34:00');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189227536773681153, 1164575944237780994, 1189227536773681152, '000000', '2', '待提交', 1, '3', '小组长审批', '1', 'role:1,role:3', 2, NULL, NULL, '2023-12-26 15:25:42', '2023-12-26 15:25:42');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189227545560748032, 1164575944237780994, 1189227536773681152, '000000', '3', '小组长审批', 1, '5,7', '大组长审批,hr审批', '1', 'role:1,role:3', 2, NULL, 'undefined', '2023-12-26 15:33:01', '2023-12-26 15:33:01');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189227579673022465, 1164575944237780995, 1189227579673022464, '000000', '2', '待提交', 1, '3', '小组长审批', '1', 'role:1,role:3', 2, NULL, NULL, '2023-12-26 15:25:52', '2023-12-26 15:25:52');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189227589701603328, 1164575944237780995, 1189227579673022464, '000000', '3', '小组长审批', 1, '5,7', '大组长审批,董事长审批', '1', 'role:1,role:3', 2, NULL, 'undefined', '2023-12-26 15:26:19', '2023-12-26 15:26:19');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189227701257506816, 1164575944237780995, 1189227579673022464, '000000', '5', '大组长审批', 1, '6', '部门经理审批', '1', 'role:1,role:3', 2, NULL, '4', '2023-12-26 15:26:34', '2023-12-26 15:26:34');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189227701257506817, 1164575944237780995, 1189227579673022464, '000000', '7', '董事长审批', 1, '9', '结束2', '1', 'role:1,role:3', 8, NULL, '4', '2023-12-26 15:26:41', '2023-12-26 15:26:41');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189227765442940928, 1164575944237780995, 1189227579673022464, '000000', '6', '部门经理审批', 1, NULL, NULL, NULL, 'role:1,role:3', 8, NULL, NULL, '2023-12-26 15:26:41', '2023-12-26 15:26:41');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189229387627761664, 1164575944237780994, 1189227536773681152, '000000', '5', '大组长审批', 1, '6', '部门经理审批', '1', 'role:1,role:3', 2, NULL, 'undefined', '2023-12-26 15:33:11', '2023-12-26 15:33:11');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189229387627761665, 1164575944237780994, 1189227536773681152, '000000', '7', 'hr审批', 1, '43563e5c-42fb-4f46-936d-70f8727943bf', '董事长审批', '1', 'role:1,role:3', 2, NULL, 'undefined', '2023-12-26 15:33:33', '2023-12-26 15:33:33');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189229431856697344, 1164575944237780994, 1189227536773681152, '000000', '6', '部门经理审批', 1, '43563e5c-42fb-4f46-936d-70f8727943bf', '董事长审批', '1', 'role:1,role:3', 2, NULL, 'undefined', '2023-12-26 15:33:18', '2023-12-26 15:33:18');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189229521111486464, 1164575944237780994, 1189227536773681152, '000000', '43563e5c-42fb-4f46-936d-70f8727943bf', '董事长审批', 1, 'd34fb004-0bf5-4ad7-8e05-82200e6f9e78', '结束', '1', 'role:1,role:3', 8, NULL, 'undefined', '2023-12-26 15:33:41', '2023-12-26 15:33:41');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189229637385981952, 1164575944237780993, 1189227464275136512, '000000', '4', '大组长审批', 1, '6', '部门经理审批', '1', 'role:1,role:3', 2, NULL, 'undefined', '2023-12-26 15:39:50', '2023-12-26 15:39:50');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189229755195592704, 1164575944237780992, 1189227307726934016, '000000', '4', '部门经理审批', 1, '9edc9b26-cab4-4fd4-9a30-c89f11626911', 'hr审批', '1', 'role:1,role:3', 2, NULL, '4', '2023-12-26 15:34:38', '2023-12-26 15:34:38');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189229793711886336, 1164575944237780992, 1189227307726934016, '000000', '9edc9b26-cab4-4fd4-9a30-c89f11626911', 'hr审批', 1, 'fa0fe17b-66d2-458d-b420-fec5cb14f73d', '结束', '1', 'role:1,role:3', 8, NULL, 'undefined', '2023-12-26 15:34:41', '2023-12-26 15:34:41');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189229841300459520, 1164867267142488064, 1189227403407396864, '000000', '80e10f4c-452c-4a79-b608-84e75831a437', '中间节点3', 1, '3893b8ab-355a-483f-ac34-e781f1f5d4ca', '结束', '1', NULL, 8, NULL, 'undefined', '2023-12-26 15:40:00', '2023-12-26 15:40:00');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189231103861460992, 1164575944237780993, 1189227464275136512, '000000', '6', '部门经理审批', 1, '8', '结束', '1', 'role:1,role:3', 8, NULL, 'undefined', '2023-12-26 15:39:56', '2023-12-26 15:39:56');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189232477701541889, 1164575944237780992, 1189232477701541888, '000000', '2', '待提交', 1, '3', '组长审批', '1', 'role:1,role:2', 2, NULL, NULL, '2023-12-26 15:46:04', '2023-12-26 15:46:04');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189232513973882881, 1164867267142488064, 1189232513973882880, '000000', '2', '中间节点1', 1, '0fbb9fbe-e4bd-4280-94f4-a8f939b760e2', '中间节点2', '1', NULL, 2, NULL, NULL, '2023-12-26 15:46:03', '2023-12-26 15:46:03');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189232547490566144, 1164575944237780993, 1189232547486371840, '000000', '2', '待提交', 1, '3', '组长审批', '1', 'role:1,role:3', 2, NULL, NULL, '2023-12-26 15:45:59', '2023-12-26 15:45:59');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189232584807288833, 1164575944237780994, 1189232584807288832, '000000', '2', '待提交', 1, '3', '小组长审批', '1', 'role:1,role:3', 2, NULL, NULL, '2023-12-26 15:45:58', '2023-12-26 15:45:58');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189232624221163521, 1164575944237780995, 1189232624221163520, '000000', '2', '待提交', 1, '3', '小组长审批', '1', 'role:1,role:3', 2, NULL, NULL, '2023-12-26 15:45:56', '2023-12-26 15:45:56');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189232638423076864, 1164575944237780995, 1189232624221163520, '000000', '3', '小组长审批', 1, '5,7', '大组长审批,董事长审批', '1', 'role:1,role:3', 2, NULL, 'undefined', '2023-12-27 02:20:15', '2023-12-27 02:20:15');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189232645964435456, 1164575944237780994, 1189232584807288832, '000000', '3', '小组长审批', 1, '5,7', '大组长审批,hr审批', '1', 'role:1,role:3', 2, NULL, 'undefined', '2023-12-26 23:40:30', '2023-12-26 23:40:30');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189232653518376960, 1164575944237780993, 1189232547486371840, '000000', '3', '组长审批', 1, '4', '大组长审批', '1', 'role:1,role:3', 2, NULL, 'undefined', '2023-12-26 15:52:44', '2023-12-26 15:52:44');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189527982549635073, 1164575944237780993, 1189527982549635072, '000000', '2', '待提交', 1, '3', '组长审批', '1', 'role:1,role:3', 2, NULL, NULL, '2023-12-27 11:19:34', '2023-12-27 11:19:34');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189527994868305920, 1164575944237780993, 1189527982549635072, '000000', '3', '组长审批', 1, '4', '大组长审批', '1', 'role:1,role:3', 2, NULL, 'undefined', '2023-12-27 11:26:00', '2023-12-27 11:26:00');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189529705775239169, 1164575944237780993, 1189529705775239168, '000000', '2', '待提交', 1, '3', '组长审批', '1', 'role:1,role:3', 2, NULL, NULL, '2023-12-27 11:26:25', '2023-12-27 11:26:25');
INSERT INTO `flow_his_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `target_node_code`, `target_node_name`, `approver`, `permission_flag`, `flow_status`, `gateway_node`, `message`, `create_time`, `update_time`) VALUES (1189529715384389632, 1164575944237780993, 1189529705775239168, '000000', '3', '组长审批', 1, '7', '董事长审批', '1', 'role:1,role:3', 2, NULL, '4', '2023-12-27 11:26:36', '2023-12-27 11:26:36');
COMMIT;

-- ----------------------------
-- Table structure for flow_instance
-- ----------------------------
DROP TABLE IF EXISTS `flow_instance`;
CREATE TABLE `flow_instance` (
                                 `id` bigint NOT NULL COMMENT '主键id',
                                 `definition_id` bigint NOT NULL COMMENT '对应flow_definition表的id',
                                 `business_id` varchar(40) NOT NULL COMMENT '业务id',
                                 `node_type` tinyint(1) NOT NULL COMMENT '结点类型（0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关）',
                                 `node_code` varchar(40) NOT NULL COMMENT '流程节点编码',
                                 `node_name` varchar(100) DEFAULT NULL COMMENT '流程节点名称',
                                 `flow_status` tinyint(1) NOT NULL COMMENT '流程状态（0待提交 1审批中 2 审批通过 8已完成 9已驳回 10失效）',
                                 `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
                                 `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                 `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                                 `ext` varchar(500) DEFAULT NULL COMMENT '扩展字段',
                                 PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC COMMENT='流程实例表';

-- ----------------------------
-- Records of flow_instance
-- ----------------------------
BEGIN;
INSERT INTO `flow_instance` (`id`, `definition_id`, `business_id`, `node_type`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_time`, `ext`) VALUES (1189227307726934016, 1164575944237780992, '1739547781112139776', 1, '9edc9b26-cab4-4fd4-9a30-c89f11626911', 'hr审批', 8, '1', '2023-12-26 15:24:45', '2023-12-26 15:34:41', NULL);
INSERT INTO `flow_instance` (`id`, `definition_id`, `business_id`, `node_type`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_time`, `ext`) VALUES (1189227403407396864, 1164867267142488064, '1739547876775825408', 1, '80e10f4c-452c-4a79-b608-84e75831a437', '中间节点3', 8, '1', '2023-12-26 15:25:08', '2023-12-26 15:40:00', NULL);
INSERT INTO `flow_instance` (`id`, `definition_id`, `business_id`, `node_type`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_time`, `ext`) VALUES (1189227464275136512, 1164575944237780993, '1739547937656147968', 1, '6', '部门经理审批', 8, '1', '2023-12-26 15:25:22', '2023-12-26 15:39:56', NULL);
INSERT INTO `flow_instance` (`id`, `definition_id`, `business_id`, `node_type`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_time`, `ext`) VALUES (1189227536773681152, 1164575944237780994, '1739548010154692608', 1, '43563e5c-42fb-4f46-936d-70f8727943bf', '董事长审批', 8, '1', '2023-12-26 15:25:40', '2023-12-26 15:33:41', NULL);
INSERT INTO `flow_instance` (`id`, `definition_id`, `business_id`, `node_type`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_time`, `ext`) VALUES (1189227579673022464, 1164575944237780995, '1739548053058228224', 1, '6', '部门经理审批', 8, '1', '2023-12-26 15:25:50', '2023-12-26 15:26:41', NULL);
INSERT INTO `flow_instance` (`id`, `definition_id`, `business_id`, `node_type`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_time`, `ext`) VALUES (1189232477701541888, 1164575944237780992, '1739552951107719168', 1, '3', '组长审批', 1, '1', '2023-12-26 15:45:18', '2023-12-26 15:46:04', NULL);
INSERT INTO `flow_instance` (`id`, `definition_id`, `business_id`, `node_type`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_time`, `ext`) VALUES (1189232513973882880, 1164867267142488064, '1739552987325534208', 1, '0fbb9fbe-e4bd-4280-94f4-a8f939b760e2', '中间节点2', 1, '1', '2023-12-26 15:45:26', '2023-12-26 15:46:03', NULL);
INSERT INTO `flow_instance` (`id`, `definition_id`, `business_id`, `node_type`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_time`, `ext`) VALUES (1189232547486371840, 1164575944237780993, '1739553020846411776', 1, '4', '大组长审批', 1, '1', '2023-12-26 15:45:34', '2023-12-26 15:52:44', NULL);
INSERT INTO `flow_instance` (`id`, `definition_id`, `business_id`, `node_type`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_time`, `ext`) VALUES (1189232584807288832, 1164575944237780994, '1739553058163134464', 1, '5', '大组长审批', 1, '1', '2023-12-26 15:45:43', '2023-12-26 23:40:30', NULL);
INSERT INTO `flow_instance` (`id`, `definition_id`, `business_id`, `node_type`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_time`, `ext`) VALUES (1189232624221163520, 1164575944237780995, '1739553097564426240', 1, '5', '大组长审批', 1, '1', '2023-12-26 15:45:52', '2023-12-27 02:20:15', NULL);
INSERT INTO `flow_instance` (`id`, `definition_id`, `business_id`, `node_type`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_time`, `ext`) VALUES (1189527982549635072, 1164575944237780993, '1739848455930646528', 1, '4', '大组长审批', 1, '1', '2023-12-27 11:19:31', '2023-12-27 11:26:00', NULL);
INSERT INTO `flow_instance` (`id`, `definition_id`, `business_id`, `node_type`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_time`, `ext`) VALUES (1189529705775239168, 1164575944237780993, '1739850179168833536', 1, '7', '董事长审批', 1, '1', '2023-12-27 11:26:22', '2023-12-27 11:26:36', NULL);
COMMIT;

-- ----------------------------
-- Table structure for flow_node
-- ----------------------------
DROP TABLE IF EXISTS `flow_node`;
CREATE TABLE `flow_node` (
                             `id` bigint unsigned NOT NULL COMMENT '主键id',
                             `node_type` tinyint(1) NOT NULL COMMENT '节点类型（0开始节点 1中间节点 2结束结点 3互斥网关 4并行网关）',
                             `definition_id` bigint NOT NULL COMMENT '流程定义id',
                             `node_code` varchar(100) NOT NULL COMMENT '流程节点编码',
                             `node_name` varchar(100) DEFAULT NULL COMMENT '流程节点名称',
                             `permission_flag` varchar(200) DEFAULT NULL COMMENT '权限标识（权限类型:权限标识，可以多个，如role:1,role:2)',
                             `coordinate` varchar(100) DEFAULT NULL COMMENT '坐标',
                             `skip_any_node` varchar(100) DEFAULT 'N' COMMENT '是否可以退回任意节点（Y是 N否）',
                             `version` varchar(20) NOT NULL COMMENT '版本',
                             `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                             `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                             PRIMARY KEY (`id`) USING BTREE,
                             UNIQUE KEY `info_id_code` (`definition_id`,`node_code`) USING BTREE COMMENT '保证一个流程中node_code是唯一的'
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC COMMENT='流程结点表';

-- ----------------------------
-- Records of flow_node
-- ----------------------------
BEGIN;
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391839938088961, 0, 1164575944237780992, '1', '开始', NULL, '120,280|120,280', 'N', '1.0', '2023-12-27 02:18:32', '2023-12-27 02:18:32');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391839938088963, 1, 1164575944237780992, '2', '待提交', 'role:1,role:2', '280,280|280,280', 'N', '1.0', '2023-12-27 02:18:32', '2023-12-27 02:18:32');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391839938088965, 1, 1164575944237780992, '3', '组长审批', 'role:1,role:3', '480,280|480,280', 'N', '1.0', '2023-12-27 02:18:32', '2023-12-27 02:18:32');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391839938088967, 1, 1164575944237780992, '4', '部门经理审批', 'role:1,role:3', '700,280|700,280', 'N', '1.0', '2023-12-27 02:18:32', '2023-12-27 02:18:32');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391839938088970, 1, 1164575944237780992, '9edc9b26-cab4-4fd4-9a30-c89f11626911', 'hr审批', 'role:1,role:3', '920,280|920,280', 'Y', '1.0', '2023-12-27 02:18:33', '2023-12-27 02:18:33');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391839938088972, 2, 1164575944237780992, 'fa0fe17b-66d2-458d-b420-fec5cb14f73d', '结束', NULL, '1120,280|1120,280', 'N', '1.0', '2023-12-27 02:18:33', '2023-12-27 02:18:33');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391860049776641, 0, 1164575944237780994, '1', '开始', NULL, '140,180|140,180', 'N', '1.0', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391860049776643, 1, 1164575944237780994, '2', '待提交', 'role:1,role:3', '280,180|280,180', 'N', '1.0', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391860049776645, 1, 1164575944237780994, '3', '小组长审批', 'role:1,role:3', '480,180|480,180', 'N', '1.0', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391860049776647, 4, 1164575944237780994, 'f06c0d62-3983-4503-ad1f-f581a89727e6', NULL, NULL, '640,180', 'N', '1.0', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391860049776650, 1, 1164575944237780994, '5', '大组长审批', 'role:1,role:3', '880,140|880,140', 'N', '1.0', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391860049776652, 1, 1164575944237780994, '6', '部门经理审批', 'role:1,role:3', '1100,140|1100,140', 'N', '1.0', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391860049776654, 4, 1164575944237780994, 'd7de884d-e86f-4483-be14-b4350d93a079', NULL, NULL, '1100,300', 'N', '1.0', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391860049776656, 1, 1164575944237780994, '43563e5c-42fb-4f46-936d-70f8727943bf', '董事长审批', 'role:1,role:3', '1100,440|1100,440', 'N', '1.0', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391860049776658, 2, 1164575944237780994, 'd34fb004-0bf5-4ad7-8e05-82200e6f9e78', '结束', NULL, '1100,600|1100,600', 'N', '1.0', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391860049776659, 1, 1164575944237780994, '7', 'hr审批', 'role:1,role:3', '880,300|880,300', 'N', '1.0', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391879658147841, 0, 1164575944237780995, '1', '开始', NULL, '140,220|140,220', 'N', '1.0', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391879658147843, 1, 1164575944237780995, '2', '待提交', 'role:1,role:3', '300,220|300,220', 'N', '1.0', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391879658147845, 1, 1164575944237780995, '3', '小组长审批', 'role:1,role:3', '500,220|500,220', 'N', '1.0', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391879658147847, 4, 1164575944237780995, 'e8d342f3-1353-415f-af62-c02f33a083bd', NULL, NULL, '660,220', 'N', '1.0', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391879658147850, 1, 1164575944237780995, '5', '大组长审批', 'role:1,role:3', '820,120|820,120', 'N', '1.0', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391879658147852, 1, 1164575944237780995, '6', '部门经理审批', 'role:1,role:3', '1040,120|1040,120', 'N', '1.0', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391879662342145, 2, 1164575944237780995, '8', '结束1', NULL, '1240,120|1240,120', 'N', '1.0', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391879662342146, 1, 1164575944237780995, '7', '董事长审批', 'role:1,role:3', '820,280|820,280', 'N', '1.0', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189391879662342149, 2, 1164575944237780995, '9', '结束2', NULL, '1240,280|1240,280', 'N', '1.0', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189528826661703681, 0, 1164867267142488064, 'f6c8ca02-6440-4f49-a35f-dfe689e38263', '开始', NULL, '160,200|160,200', 'N', '1.0', '2023-12-27 11:22:53', '2023-12-27 11:22:53');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189528826661703683, 1, 1164867267142488064, '2', '中间节点1', NULL, '380,200|380,200', 'N', '1.0', '2023-12-27 11:22:53', '2023-12-27 11:22:53');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189528826661703685, 1, 1164867267142488064, '0fbb9fbe-e4bd-4280-94f4-a8f939b760e2', '中间节点2', NULL, '600,200|600,200', 'N', '1.0', '2023-12-27 11:22:53', '2023-12-27 11:22:53');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189528826661703687, 1, 1164867267142488064, '80e10f4c-452c-4a79-b608-84e75831a437', '中间节点3', NULL, '840,200|840,200', 'N', '1.0', '2023-12-27 11:22:53', '2023-12-27 11:22:53');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189528826661703690, 2, 1164867267142488064, '3893b8ab-355a-483f-ac34-e781f1f5d4ca', '结束', NULL, '1060,200|1060,200', 'N', '1.0', '2023-12-27 11:22:53', '2023-12-27 11:22:53');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189528826661703691, 3, 1164867267142488064, 'f038c246-b219-4316-89b9-991ba067c740', NULL, NULL, '700,80', 'N', '1.0', '2023-12-27 11:22:53', '2023-12-27 11:22:53');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189528918848311297, 0, 1164575944237780993, '1', '开始', NULL, '140,300|140,300', 'N', '1.0', '2023-12-27 11:23:15', '2023-12-27 11:23:15');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189528918848311299, 1, 1164575944237780993, '2', '待提交', 'role:1,role:3', '300,300|300,300', 'N', '1.0', '2023-12-27 11:23:15', '2023-12-27 11:23:15');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189528918848311301, 1, 1164575944237780993, '3', '组长审批', 'role:1,role:3', '500,300|500,300', 'N', '1.0', '2023-12-27 11:23:15', '2023-12-27 11:23:15');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189528918848311303, 3, 1164575944237780993, '50a177f6-d9a7-44e8-96d6-afc6d1362192', NULL, NULL, '660,300', 'N', '1.0', '2023-12-27 11:23:15', '2023-12-27 11:23:15');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189528918848311306, 1, 1164575944237780993, '4', '大组长审批', 'role:1,role:3', '840,180|840,180', 'N', '1.0', '2023-12-27 11:23:15', '2023-12-27 11:23:15');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189528918848311308, 1, 1164575944237780993, '6', '部门经理审批', 'role:1,role:3', '1040,180|1040,180', 'N', '1.0', '2023-12-27 11:23:15', '2023-12-27 11:23:15');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189528918848311311, 2, 1164575944237780993, '8', '结束', NULL, '1200,300|1200,300', 'N', '1.0', '2023-12-27 11:23:15', '2023-12-27 11:23:15');
INSERT INTO `flow_node` (`id`, `node_type`, `definition_id`, `node_code`, `node_name`, `permission_flag`, `coordinate`, `skip_any_node`, `version`, `create_time`, `update_time`) VALUES (1189528918848311312, 1, 1164575944237780993, '7', '董事长审批', 'role:1,role:3', '840,420|840,420', 'N', '1.0', '2023-12-27 11:23:15', '2023-12-27 11:23:15');
COMMIT;

-- ----------------------------
-- Table structure for flow_skip
-- ----------------------------
DROP TABLE IF EXISTS `flow_skip`;
CREATE TABLE `flow_skip` (
                             `id` bigint unsigned NOT NULL COMMENT '主键id',
                             `definition_id` bigint NOT NULL COMMENT '流程定义id',
                             `node_id` bigint NOT NULL COMMENT '当前节点id',
                             `now_node_code` varchar(100) NOT NULL COMMENT '当前流程节点的编码',
                             `now_node_type` tinyint(1) DEFAULT NULL COMMENT '当前节点类型（0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关）',
                             `next_node_code` varchar(100) NOT NULL COMMENT '下一个流程节点的编码',
                             `next_node_type` tinyint(1) DEFAULT NULL COMMENT '下一个节点类型（0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关）',
                             `skip_name` varchar(100) DEFAULT NULL COMMENT '跳转名称',
                             `skip_type` varchar(40) DEFAULT NULL COMMENT '跳转类型（PASS审批通过 REJECT驳回）',
                             `skip_condition` varchar(200) DEFAULT NULL COMMENT '跳转条件',
                             `coordinate` varchar(100) DEFAULT NULL COMMENT '坐标',
                             `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                             `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                             PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC COMMENT='结点跳转关联表';

-- ----------------------------
-- Records of flow_skip
-- ----------------------------
BEGIN;
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391839938088962, 1164575944237780992, 1189391839938088961, '1', 0, '2', 1, NULL, 'PASS', NULL, '140,280;230,280', '2023-12-27 02:18:33', '2023-12-27 02:18:33');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391839938088964, 1164575944237780992, 1189391839938088963, '2', 1, '3', 1, NULL, 'PASS', NULL, '330,280;430,280', '2023-12-27 02:18:33', '2023-12-27 02:18:33');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391839938088966, 1164575944237780992, 1189391839938088965, '3', 1, '4', 1, NULL, 'PASS', NULL, '530,280;650,280', '2023-12-27 02:18:33', '2023-12-27 02:18:33');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391839938088968, 1164575944237780992, 1189391839938088967, '4', 1, '9edc9b26-cab4-4fd4-9a30-c89f11626911', 1, NULL, 'PASS', NULL, '750,280;870,280', '2023-12-27 02:18:33', '2023-12-27 02:18:33');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391839938088969, 1164575944237780992, 1189391839938088967, '4', 1, '2', 1, NULL, 'REJECT', NULL, '700,240;700,210;280,210;280,240', '2023-12-27 02:18:33', '2023-12-27 02:18:33');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391839938088971, 1164575944237780992, 1189391839938088970, '9edc9b26-cab4-4fd4-9a30-c89f11626911', 1, 'fa0fe17b-66d2-458d-b420-fec5cb14f73d', 2, NULL, 'PASS', NULL, '970,280;1100,280', '2023-12-27 02:18:33', '2023-12-27 02:18:33');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776642, 1164575944237780994, 1189391860049776641, '1', 0, '2', 1, NULL, 'PASS', NULL, '160,180;230,180', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776644, 1164575944237780994, 1189391860049776643, '2', 1, '3', 1, NULL, 'PASS', NULL, '330,180;430,180', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776646, 1164575944237780994, 1189391860049776645, '3', 1, 'f06c0d62-3983-4503-ad1f-f581a89727e6', 4, NULL, 'PASS', NULL, '530,180;615,180', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776648, 1164575944237780994, 1189391860049776647, 'f06c0d62-3983-4503-ad1f-f581a89727e6', 4, '5', 1, NULL, 'PASS', NULL, '665,180;683,180;683,140;830,140', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776649, 1164575944237780994, 1189391860049776647, 'f06c0d62-3983-4503-ad1f-f581a89727e6', 4, '7', 1, NULL, 'PASS', NULL, '665,180;685,180;685,300;830,300', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776651, 1164575944237780994, 1189391860049776650, '5', 1, '6', 1, NULL, 'PASS', NULL, '930,140;1050,140', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776653, 1164575944237780994, 1189391860049776652, '6', 1, 'd7de884d-e86f-4483-be14-b4350d93a079', 4, NULL, 'PASS', NULL, '1101,180;1101,276', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776655, 1164575944237780994, 1189391860049776654, 'd7de884d-e86f-4483-be14-b4350d93a079', 4, '43563e5c-42fb-4f46-936d-70f8727943bf', 1, NULL, 'PASS', NULL, '1102,323;1102,400', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776657, 1164575944237780994, 1189391860049776656, '43563e5c-42fb-4f46-936d-70f8727943bf', 1, 'd34fb004-0bf5-4ad7-8e05-82200e6f9e78', 2, NULL, 'PASS', NULL, '1100,480;1100,580', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776660, 1164575944237780994, 1189391860049776659, '7', 1, 'd7de884d-e86f-4483-be14-b4350d93a079', 4, NULL, 'PASS', NULL, '930,300;1075,300', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391860049776661, 1164575944237780994, 1189391860049776659, '7', 1, '3', 1, NULL, 'REJECT', NULL, '880,340;880,360;480,360;480,220', '2023-12-27 02:18:37', '2023-12-27 02:18:37');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391879658147842, 1164575944237780995, 1189391879658147841, '1', 0, '2', 1, NULL, 'PASS', NULL, '160,220;250,220', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391879658147844, 1164575944237780995, 1189391879658147843, '2', 1, '3', 1, NULL, 'PASS', NULL, '350,220;450,220', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391879658147846, 1164575944237780995, 1189391879658147845, '3', 1, 'e8d342f3-1353-415f-af62-c02f33a083bd', 4, NULL, 'PASS', NULL, '550,220;635,220', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391879658147848, 1164575944237780995, 1189391879658147847, 'e8d342f3-1353-415f-af62-c02f33a083bd', 4, '5', 1, NULL, 'PASS', NULL, '685,220;716,220;716,120;770,120', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391879658147849, 1164575944237780995, 1189391879658147847, 'e8d342f3-1353-415f-af62-c02f33a083bd', 4, '7', 1, NULL, 'PASS', NULL, '685,220;715,220;715,280;770,280', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391879658147851, 1164575944237780995, 1189391879658147850, '5', 1, '6', 1, NULL, 'PASS', NULL, '870,120;990,120', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391879662342144, 1164575944237780995, 1189391879658147852, '6', 1, '8', 2, NULL, 'PASS', NULL, '1090,120;1220,120', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391879662342147, 1164575944237780995, 1189391879662342146, '7', 1, '9', 2, NULL, 'PASS', NULL, '870,280;1220,280', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189391879662342148, 1164575944237780995, 1189391879662342146, '7', 1, '3', 1, NULL, 'REJECT', NULL, '820,320;820,350;500,350;500,260', '2023-12-27 02:18:42', '2023-12-27 02:18:42');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189528826661703682, 1164867267142488064, 1189528826661703681, 'f6c8ca02-6440-4f49-a35f-dfe689e38263', 0, '2', 1, NULL, 'PASS', NULL, '180,200;330,200', '2023-12-27 11:22:53', '2023-12-27 11:22:53');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189528826661703684, 1164867267142488064, 1189528826661703683, '2', 1, '0fbb9fbe-e4bd-4280-94f4-a8f939b760e2', 1, NULL, 'PASS', NULL, '430,200;550,200', '2023-12-27 11:22:53', '2023-12-27 11:22:53');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189528826661703686, 1164867267142488064, 1189528826661703685, '0fbb9fbe-e4bd-4280-94f4-a8f939b760e2', 1, '80e10f4c-452c-4a79-b608-84e75831a437', 1, NULL, 'PASS', NULL, '650,200;790,200', '2023-12-27 11:22:53', '2023-12-27 11:22:53');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189528826661703688, 1164867267142488064, 1189528826661703687, '80e10f4c-452c-4a79-b608-84e75831a437', 1, '3893b8ab-355a-483f-ac34-e781f1f5d4ca', 2, NULL, 'PASS', NULL, '890,200;1040,200', '2023-12-27 11:22:53', '2023-12-27 11:22:53');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189528826661703689, 1164867267142488064, 1189528826661703687, '80e10f4c-452c-4a79-b608-84e75831a437', 1, 'f038c246-b219-4316-89b9-991ba067c740', 3, NULL, 'REJECT', NULL, '840,160;840,79;724,79', '2023-12-27 11:22:53', '2023-12-27 11:22:53');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189528826661703692, 1164867267142488064, 1189528826661703691, 'f038c246-b219-4316-89b9-991ba067c740', 3, '0fbb9fbe-e4bd-4280-94f4-a8f939b760e2', 1, '请假时间大于4天', 'REJECT', '@@gt@@|flag@@gt@@4', '675,80;600,80;600,160|600,80', '2023-12-27 11:22:53', '2023-12-27 11:22:53');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189528826661703693, 1164867267142488064, 1189528826661703691, 'f038c246-b219-4316-89b9-991ba067c740', 3, '2', 1, '请假时间小于等于4天', 'REJECT', '@@ge@@|flag@@ge@@4', '700,55;700,35;380,35;380,160|540,35', '2023-12-27 11:22:53', '2023-12-27 11:22:53');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189528918848311298, 1164575944237780993, 1189528918848311297, '1', 0, '2', 1, NULL, 'PASS', NULL, '160,300;250,300', '2023-12-27 11:23:15', '2023-12-27 11:23:15');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189528918848311300, 1164575944237780993, 1189528918848311299, '2', 1, '3', 1, NULL, 'PASS', NULL, '350,300;450,300', '2023-12-27 11:23:15', '2023-12-27 11:23:15');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189528918848311302, 1164575944237780993, 1189528918848311301, '3', 1, '50a177f6-d9a7-44e8-96d6-afc6d1362192', 3, NULL, 'PASS', NULL, '550,300;635,300', '2023-12-27 11:23:15', '2023-12-27 11:23:15');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189528918848311304, 1164575944237780993, 1189528918848311303, '50a177f6-d9a7-44e8-96d6-afc6d1362192', 3, '4', 1, '请假时间小于等于4天', 'PASS', '@@le@@|flag@@le@@4', '660,275;660,180;790,180|660,225', '2023-12-27 11:23:15', '2023-12-27 11:23:15');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189528918848311305, 1164575944237780993, 1189528918848311303, '50a177f6-d9a7-44e8-96d6-afc6d1362192', 3, '7', 1, '请假时间大于4天', 'PASS', '@@gt@@|flag@@gt@@4', '660,325;660,420;790,420|660,375', '2023-12-27 11:23:15', '2023-12-27 11:23:15');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189528918848311307, 1164575944237780993, 1189528918848311306, '4', 1, '6', 1, NULL, 'PASS', NULL, '890,180;990,180', '2023-12-27 11:23:15', '2023-12-27 11:23:15');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189528918848311309, 1164575944237780993, 1189528918848311308, '6', 1, '8', 2, NULL, 'PASS', NULL, '1090,180;1141,180;1141,300;1180,300', '2023-12-27 11:23:15', '2023-12-27 11:23:15');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189528918848311310, 1164575944237780993, 1189528918848311308, '6', 1, '4', 1, NULL, 'REJECT', NULL, '1040,140;1040,120;840,120;840,140', '2023-12-27 11:23:15', '2023-12-27 11:23:15');
INSERT INTO `flow_skip` (`id`, `definition_id`, `node_id`, `now_node_code`, `now_node_type`, `next_node_code`, `next_node_type`, `skip_name`, `skip_type`, `skip_condition`, `coordinate`, `create_time`, `update_time`) VALUES (1189528918848311313, 1164575944237780993, 1189528918848311312, '7', 1, '8', 2, NULL, 'PASS', NULL, '890,420;910,420;910,300;1180,300', '2023-12-27 11:23:15', '2023-12-27 11:23:15');
COMMIT;

-- ----------------------------
-- Table structure for flow_task
-- ----------------------------
DROP TABLE IF EXISTS `flow_task`;
CREATE TABLE `flow_task` (
                             `id` bigint NOT NULL COMMENT '主键id',
                             `definition_id` bigint NOT NULL COMMENT '对应flow_definition表的id',
                             `instance_id` bigint NOT NULL COMMENT '对应flow_instance表的id',
                             `tenant_id` varchar(40) DEFAULT NULL COMMENT '租户id',
                             `node_code` varchar(100) NOT NULL COMMENT '节点编码',
                             `node_name` varchar(100) DEFAULT NULL COMMENT '节点名称',
                             `node_type` tinyint(1) NOT NULL COMMENT '节点类型（0开始节点 1中间节点 2结束节点 3互斥网关 4并行网关）',
                             `permission_flag` varchar(200) DEFAULT NULL COMMENT '权限标识（权限类型:权限标识，可以多个，如role:1,role:2)',
                             `flow_status` tinyint(1) NOT NULL COMMENT '流程状态（0待提交 1审批中 2 审批通过 8已完成 9已驳回 10失效）',
                             `approver` varchar(40) DEFAULT NULL COMMENT '审批者',
                             `assignee` varchar(40) DEFAULT NULL COMMENT '转办人',
                             `gateway_node` varchar(40) DEFAULT NULL COMMENT '所属并行网关节点编码',
                             `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                             `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                             PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC COMMENT='待办任务表';

-- ----------------------------
-- Records of flow_task
-- ----------------------------
BEGIN;
INSERT INTO `flow_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `permission_flag`, `flow_status`, `approver`, `assignee`, `gateway_node`, `create_time`, `update_time`) VALUES (1189232666277449728, 1164867267142488064, 1189232513973882880, '000000', '0fbb9fbe-e4bd-4280-94f4-a8f939b760e2', '中间节点2', 1, NULL, 1, '1', NULL, NULL, '2023-12-26 15:46:03', '2023-12-26 15:46:03');
INSERT INTO `flow_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `permission_flag`, `flow_status`, `approver`, `assignee`, `gateway_node`, `create_time`, `update_time`) VALUES (1189232674275987456, 1164575944237780992, 1189232477701541888, '000000', '3', '组长审批', 1, 'role:1,role:3', 1, '1', NULL, NULL, '2023-12-26 15:46:04', '2023-12-26 15:46:04');
INSERT INTO `flow_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `permission_flag`, `flow_status`, `approver`, `assignee`, `gateway_node`, `create_time`, `update_time`) VALUES (1189234351720763392, 1164575944237780993, 1189232547486371840, '000000', '4', '大组长审批', 1, 'role:1,role:3', 1, '1', NULL, NULL, '2023-12-26 15:52:44', '2023-12-26 15:52:44');
INSERT INTO `flow_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `permission_flag`, `flow_status`, `approver`, `assignee`, `gateway_node`, `create_time`, `update_time`) VALUES (1189352067601403904, 1164575944237780994, 1189232584807288832, '000000', '5', '大组长审批', 1, 'role:1,role:3', 1, '1', NULL, NULL, '2023-12-26 23:40:30', '2023-12-26 23:40:30');
INSERT INTO `flow_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `permission_flag`, `flow_status`, `approver`, `assignee`, `gateway_node`, `create_time`, `update_time`) VALUES (1189352067601403905, 1164575944237780994, 1189232584807288832, '000000', '7', 'hr审批', 1, 'role:1,role:3', 1, '1', NULL, NULL, '2023-12-26 23:40:30', '2023-12-26 23:40:30');
INSERT INTO `flow_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `permission_flag`, `flow_status`, `approver`, `assignee`, `gateway_node`, `create_time`, `update_time`) VALUES (1189392271607468032, 1164575944237780995, 1189232624221163520, '000000', '5', '大组长审批', 1, 'role:1,role:3', 1, '1', NULL, NULL, '2023-12-27 02:20:15', '2023-12-27 02:20:15');
INSERT INTO `flow_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `permission_flag`, `flow_status`, `approver`, `assignee`, `gateway_node`, `create_time`, `update_time`) VALUES (1189392271607468033, 1164575944237780995, 1189232624221163520, '000000', '7', '董事长审批', 1, 'role:1,role:3', 1, '1', NULL, NULL, '2023-12-27 02:20:15', '2023-12-27 02:20:15');
INSERT INTO `flow_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `permission_flag`, `flow_status`, `approver`, `assignee`, `gateway_node`, `create_time`, `update_time`) VALUES (1189529612871405568, 1164575944237780993, 1189527982549635072, '000000', '4', '大组长审批', 1, 'role:1,role:3', 1, '1', NULL, NULL, '2023-12-27 11:26:00', '2023-12-27 11:26:00');
INSERT INTO `flow_task` (`id`, `definition_id`, `instance_id`, `tenant_id`, `node_code`, `node_name`, `node_type`, `permission_flag`, `flow_status`, `approver`, `assignee`, `gateway_node`, `create_time`, `update_time`) VALUES (1189529761874055168, 1164575944237780993, 1189529705775239168, '000000', '7', '董事长审批', 1, 'role:1,role:3', 1, '1', NULL, NULL, '2023-12-27 11:26:36', '2023-12-27 11:26:36');
COMMIT;

CREATE TABLE `test_leave` (
                              `id` bigint unsigned NOT NULL COMMENT '主键',
                              `type` tinyint NOT NULL COMMENT '请假类型',
                              `reason` varchar(500)  NOT NULL COMMENT '请假原因',
                              `start_time` datetime NOT NULL COMMENT '开始时间',
                              `end_time` datetime NOT NULL COMMENT '结束时间',
                              `day` tinyint DEFAULT NULL COMMENT '请假天数',
                              `instance_id` bigint DEFAULT NULL COMMENT '流程实例的id',
                              `node_code` varchar(100)  DEFAULT NULL COMMENT '节点编码',
                              `node_name` varchar(100)  DEFAULT NULL COMMENT '流程节点名称',
                              `flow_status` tinyint(1) DEFAULT NULL COMMENT '流程状态（0待提交 1审批中 2 审批通过 8已完成 9已驳回 10失效）',
                              `create_by` varchar(64)  DEFAULT '' COMMENT '创建者',
                              `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                              `update_by` varchar(64)  DEFAULT '' COMMENT '更新者',
                              `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                              `del_flag` char(1)  DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
                              PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB COMMENT='OA 请假申请表';

BEGIN;
INSERT INTO `test_leave` (`id`, `type`, `reason`, `start_time`, `end_time`, `day`, `instance_id`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1739547781112139776, 0, '1', '2023-12-26 15:24:40', '2023-12-26 15:24:42', 1, 1189227307726934016, '9edc9b26-cab4-4fd4-9a30-c89f11626911', 'hr审批', 8, 'admin', '2023-12-26 15:24:45', 'admin', '2023-12-26 15:34:41', '0');
INSERT INTO `test_leave` (`id`, `type`, `reason`, `start_time`, `end_time`, `day`, `instance_id`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1739547876775825408, 4, '1', '2023-12-26 15:25:01', '2023-12-26 15:25:02', 4, 1189227403407396864, '80e10f4c-452c-4a79-b608-84e75831a437', '中间节点3', 8, 'admin', '2023-12-26 15:25:08', 'admin', '2023-12-26 15:40:00', '0');
INSERT INTO `test_leave` (`id`, `type`, `reason`, `start_time`, `end_time`, `day`, `instance_id`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1739547937656147968, 1, '1', '2023-12-26 15:25:18', '2023-12-26 15:25:19', 4, 1189227464275136512, '6', '部门经理审批', 8, 'admin', '2023-12-26 15:25:22', 'admin', '2023-12-26 15:39:56', '0');
INSERT INTO `test_leave` (`id`, `type`, `reason`, `start_time`, `end_time`, `day`, `instance_id`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1739548010154692608, 2, '1', '2023-12-26 15:25:35', '2023-12-26 15:25:37', 4, 1189227536773681152, '43563e5c-42fb-4f46-936d-70f8727943bf', '董事长审批', 8, 'admin', '2023-12-26 15:25:40', 'admin', '2023-12-26 15:33:41', '0');
INSERT INTO `test_leave` (`id`, `type`, `reason`, `start_time`, `end_time`, `day`, `instance_id`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1739548053058228224, 3, '1', '2023-12-26 15:25:46', '2023-12-26 15:25:47', 4, 1189227579673022464, '6', '部门经理审批', 8, 'admin', '2023-12-26 15:25:50', 'admin', '2023-12-26 15:26:41', '0');
INSERT INTO `test_leave` (`id`, `type`, `reason`, `start_time`, `end_time`, `day`, `instance_id`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1739552951107719168, 0, '4', '2023-12-26 15:45:13', '2023-12-26 15:45:14', 4, 1189232477701541888, '3', '组长审批', 1, 'admin', '2023-12-26 15:45:18', 'admin', '2023-12-26 15:46:04', '0');
INSERT INTO `test_leave` (`id`, `type`, `reason`, `start_time`, `end_time`, `day`, `instance_id`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1739552987325534208, 4, '4', '2023-12-26 15:45:23', '2023-12-26 15:45:24', 4, 1189232513973882880, '0fbb9fbe-e4bd-4280-94f4-a8f939b760e2', '中间节点2', 1, 'admin', '2023-12-26 15:45:26', 'admin', '2023-12-26 15:46:03', '0');
INSERT INTO `test_leave` (`id`, `type`, `reason`, `start_time`, `end_time`, `day`, `instance_id`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1739553020846411776, 1, '4', '2023-12-26 15:45:30', '2023-12-26 15:45:32', 4, 1189232547486371840, '4', '大组长审批', 1, 'admin', '2023-12-26 15:45:34', 'admin', '2023-12-26 15:52:44', '0');
INSERT INTO `test_leave` (`id`, `type`, `reason`, `start_time`, `end_time`, `day`, `instance_id`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1739553058163134464, 2, '4', '2023-12-26 15:45:40', '2023-12-26 15:45:41', 4, 1189232584807288832, '5', '大组长审批', 1, 'admin', '2023-12-26 15:45:43', 'admin', '2023-12-26 23:40:30', '0');
INSERT INTO `test_leave` (`id`, `type`, `reason`, `start_time`, `end_time`, `day`, `instance_id`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1739553097564426240, 3, '4', '2023-12-26 15:45:47', '2023-12-26 15:45:50', 4, 1189232624221163520, '5', '大组长审批', 1, 'admin', '2023-12-26 15:45:52', 'admin', '2023-12-27 02:20:15', '0');
INSERT INTO `test_leave` (`id`, `type`, `reason`, `start_time`, `end_time`, `day`, `instance_id`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1739848455930646528, 1, '1', '2023-12-27 11:19:25', '2023-12-27 11:19:27', 4, 1189527982549635072, '4', '大组长审批', 1, 'admin', '2023-12-27 11:19:31', 'admin', '2023-12-27 11:26:00', '0');
INSERT INTO `test_leave` (`id`, `type`, `reason`, `start_time`, `end_time`, `day`, `instance_id`, `node_code`, `node_name`, `flow_status`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1739850179168833536, 1, '1', '2023-12-27 11:26:16', '2023-12-27 11:26:18', 5, 1189529705775239168, '7', '董事长审批', 1, 'admin', '2023-12-27 11:26:22', 'admin', '2023-12-27 11:26:36', '0');
COMMIT;

INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (15, '流程状态', 'flow_status', '0', 'admin', '2023-05-07 00:47:03', 'admin', '2023-10-27 16:50:23', '流程状态');

INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (11, '请假类型', 'leave_type', '0', 'admin', '2023-04-01 23:32:00', 'admin', '2023-04-11 11:07:24', '请假类型列表');

INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (30, 0, '串行-简单', '0', 'leave_type', NULL, 'default', 'N', '0', 'admin', '2023-04-01 23:32:40', 'admin', '2023-10-20 10:04:55', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (31, 1, '串行-通过互斥', '1', 'leave_type', NULL, 'default', 'N', '0', 'admin', '2023-04-01 23:33:14', 'admin', '2023-10-20 10:04:59', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (46, 2, '并行-汇聚', '2', 'leave_type', NULL, 'default', 'N', '0', 'admin', '2023-09-13 00:17:44', 'admin', '2023-10-20 10:05:03', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (49, 3, '并行-分开', '3', 'leave_type', NULL, 'default', 'N', '0', 'admin', '2023-09-13 15:34:39', 'admin', '2023-10-20 10:05:07', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (51, 0, '串行-驳回互斥', '4', 'leave_type', NULL, 'default', 'N', '0', 'admin', '2023-10-20 10:11:57', '', NULL, '串行-驳回互斥');

INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (41, 0, '待提交', '0', 'flow_status', NULL, 'info', 'N', '0', 'admin', '2023-05-07 00:48:15', 'admin', '2023-05-07 00:50:24', '待提交');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (42, 1, '审批中', '1', 'flow_status', NULL, 'primary', 'N', '0', 'admin', '2023-05-07 00:49:27', 'admin', '2023-05-07 00:50:33', '审批中');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (43, 8, '已完成', '8', 'flow_status', NULL, 'success', 'N', '0', 'admin', '2023-05-07 00:49:59', 'admin', '2023-09-04 00:28:38', '已完成');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (44, 9, '驳回', '9', 'flow_status', NULL, 'warning', 'N', '0', 'admin', '2023-05-07 00:50:56', '', NULL, '驳回');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (45, 2, '审批通过', '2', 'flow_status', NULL, 'primary', 'N', '0', 'admin', '2023-09-04 00:29:04', 'admin', '2023-09-18 14:53:17', '审批通过');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (50, 10, '失效', '10', 'flow_status', NULL, 'info', 'N', '0', 'admin', '2023-09-20 11:24:32', 'admin', '2023-09-20 11:25:51', '失效');